CubeLoad: A Parametric Generator of Realistic OLAP Workloads
نویسندگان
چکیده
Differently from OLTP workloads, OLAP workloads are hardly predictable due to their inherently extemporary nature. Besides, obtaining real OLAP workloads by monitoring the queries actually issued in companies and organizations is quite hard. On the other hand, hardware and software benchmarking in the industrial world, as well as comparative evaluation of novel approaches in the research community, both need reference databases and workloads. In this paper we present CubeLoad, a parametric generator of workloads in the form of OLAP sessions, based on a realistic profile-based model. After describing the main features of CubeLoad, we discuss the results of some tests that show how workloads with very different features can be generated.
منابع مشابه
Business Intelligence on Non-Conventional Data
Analyse trends and moods from the environment (social networks, blogs, forums, etc.) by combining semantically-enriched UGC with corporate data A hierarchy of topics must be defined to perform effective analyses, but topics are HETEROGENEOUS FUZZY EXPRESSIVE UNPREDICTABLE META-STAR is an alternative to star-schema for modeling topic hierarchies, which combines meta-modeling, navigation tables, ...
متن کاملInvestigation of STATCOM effects on synchronous generator impedance based LOF relay with considering a realistic model for the excitation system of the generator
This paper studies the effects of static synchronous compensator (STATCOM) on synchronous generator conventional loss of field (LOF) protection. To accomplish a comprehensive study, a typical and realistic excitation system is considered for the generator by using the phase-domain generator model available in the real-time-digital-simulator. Using such a system, LOF phenomenon is realistically ...
متن کاملEvolving the Architecture of a DBMS for Modern Hardware
The major commercial database systems were designed primarily for OLTP workloads and under the assumption that processors are slow, memory is scarce, and data lives on disk. These assumption are no longer valid: OLAP workloads are now as common as OLTP workloads, multi-core processors are the norm, large memories are affordable, and frequently accessed data lives mostly in the main memory buffe...
متن کاملParallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads
Modern in-memory database systems are facing the need of efficiently supporting mixed workloads of OLTP and OLAP. A conventional approach to this requirement is to rely on ETL-style, application-driven data replication between two very different OLTP and OLAP systems, sacrificing realtime reporting on operational data. An alternative approach is to run OLTP and OLAP workloads in a single machin...
متن کاملA Workload Generator for Database System Benchmarks
There are cases in which database system benchmarks should be executed in a realistic environment to get meaningful performance results. We propose a workload generator that helps benchmarks be executed in an environment similar to the real world in terms of resource status. The workload generator can create memory-bound, CPU-bound, and I/O-bound workloads. The workload generator allows users t...
متن کامل